---
title: DB-CLL-028 — Retrieve a single request issue
summary: Retrieve a single request issue
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-028 — Retrieve a single request issue

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-028 |
| Operation type | R |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsRequestIssue |
| Criteria property | RetrieveSQL |
| Lifecycle method | AfterRetrieve |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalCaseID | Input | NUMBER | N/A | Legal case identifier the request issue belongs to |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [REQUEST_ISSUE](../database-tables.md#request_issue) | SELECT | LEGAL_CASE_SEQ_NUM, REQUEST_ISSUE_CODE, REQUEST_ISSUE_TEXT |

## Sample SQL

```sql
Select
  REQUEST_ISSUE.REQUEST_ISSUE_SEQ_NUM as RequestIssueID,
  REQUEST_ISSUE.LEGAL_CASE_SEQ_NUM as LegalCaseID,
  REQUEST_ISSUE.REQUEST_ISSUE_CODE as RequestIssueCode,
  REQUEST_ISSUE.REQUEST_ISSUE_TEXT as RequestIssueText
From
  REQUEST_ISSUE
Where
  REQUEST_ISSUE.LEGAL_CASE_SEQ_NUM = :LegalCaseID
```

## Operations and processes

- [Manage other legal parties and request issues](../operations/manage-other-legal-party-and-request-issue.md)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsRequestIssue.vb`